=============================================================
        How To Setup A *NEW* Database Manually
         Community Server 2.1 for ASP.NET 2.0
=============================================================

1. Create a new database called "CommunityServer"

2. Grant your desired login access to the new database.
	2a. If you're using Windows Authentication. Enable Integrated Security (you can run the user.sql file, 
		only recommended for development/test machines)
	2b. If you're using Sql Authentication, use Enterprise Manager to grant your SQL Login access to the 
		new database.
		
	- Note: At a minimum, Community Server will required the following database roles:
		db_securityadmin
		db_ddladmin
		db_datareader
		db_datawriter
		
3. Execute cs_2.1_CreateFullDatabase.sql

4. Execute cs_ASPNET2_Membership_Schema_Update.sql

5. Create a new community by running the cs_system_CreateCommunity stored procedure like this:
	exec dbo.cs_system_CreateCommunity 'localhost/cs', 'dev', 'admin@example.org', 'AdminUserName', 'AdminPassword', 0, 0
	
	Where you replace "localhost/cs" with your URL, and replace the Admin account email, username and password with your desired values.

	If you would like to have a sample blog and gallery created for you, change the last zero (0) to a one (1) in the line above.
	Example: exec dbo.cs_system_CreateCommunity 'localhost/cs', 'dev', 'admin@example.org', 'AdminUserName', 'AdminPassword', 0, 1

---------------------------------------------------------------------

=============================================================
  How To *UPGRADE* a CS 2.0 RTM or CS 2.1 Database Manually
       Community Server 2.1 for ASP.NET 2.0
=============================================================
  
NOTEs:
 * This is not necessary for a fresh install!
 * Upgrades from CS 2.0 FINAL or CS 2.1 beta/RC.
 * If you are upgrading from a CS 1.0 or 1.1 install, first run the appropriate scripts in the Upgrade_From_CS1.x folder.
 * If will be using ASP.NET 1.1, please download the CS 2.1 for ASP.NET 1.1 installer.

1. Execute: cs_2.x_to_2.1_upgrade.sql

2. If were already running CS 2.0 or CS 2.1 under ASP.NET 2.0, you are finished!

   ONLY if you were previously running under ASP.NET 1.1, and plan on running CS 2.1 under ASP.NET 2.0:
   Execute cs_ASPNET2_Membership_Schema_Update.sql
  
   (This updates your membership schema in the database to use the ASP.NET 2.0 membership components)
	
   Note: If you were previously running under ASP.NET 2.0, but still using 
         the backported ASP.NET 1.1 membership component (MemberRole.dll)
         then you will also need to execute the cs_ASPNET2_Membership_Schema_Update.sql 
         script to upgrade to the ASP.NET 2.0 membership components.

